Rainfall, flow and effluent characteristics for Lennox Head STP

INFORMATION ON FORMULAS AND LINKS

Data provided by Lennox Head Sewage Treatment Plant

Sydney Water Corporation

Last update: June 1999.

Date

RAIN

FLOW

NFR

BOD

GREASE

FCOL

CHLA

ALGAE

TURB

IRON

<< Label names used in Statistics Formulas below

01-Jul-97

4411

1.5

1.6

1.9

3.2

1150

02-Jul-97

0.4

4646

03-Jul-97

4407

Open the SAS.asc file - example below.

04-Jul-97

4189

05-Jul-97

1.2

4226

06-Jul-97

10.4

4567

07-Jul-97

5262

08-Jul-97

4478

09-Jul-97

4501

10-Jul-97

3756

11-Jul-97

3215

12-Jul-97

2810

Replace columns A-D with single Date entry by:

13-Jul-97

8.4

3058

14-Jul-97

7.2

3114

2.1

Insert new first column to left of DATE.

15-Jul-97

3167

0.9

2.4

1.9

9.9

2.1

550

2.2

Enter the full date of the first and second records

16-Jul-97

3079

then click Edit and use the fill function commands

17-Jul-97

3136

below.

18-Jul-97

35.2

3128

(EDIT - FILL - SERIES - [step series = 1] - AUTOFILL)

19-Jul-97

20.8

4380

20-Jul-97

5.8

4182

The result will look something like the example on

21-Jul-97

3704

the right.

22-Jul-97

0.2

3565

2.3

Delete columns B-E.

23-Jul-97

3377

24-Jul-97

19.2

3208

Replace the blanks (.) with nulls (null =NA in Excel). Apply the conditional function below.

25-Jul-97

2.4

3266

3.1

[=IF(cell=".","NA",cell)]

26-Jul-97

3257

3.2

Use the paste special to overwrite the original data range.

27-Jul-97

3373

28-Jul-97

3563

29-Jul-97

4060

3.7

1.9

9.9

2.1

1400

30-Jul-97

11.4

5549

31-Jul-97

130.6

9487

01-Aug-97

0.4

7512

02-Aug-97

5342

03-Aug-97

0.8

5163

04-Aug-97

2.2

4969

05-Aug-97

4384

06-Aug-97

0.4

4791

Label alignment not supported in HTML

07-Aug-97

4653

Adjust column widths at your peril. Columns

08-Aug-97

4361

formated to file the HTML RH Frame for

09-Aug-97

4384

800*600 screen resolution

10-Aug-97

4209

If a column contains only NAs, then some statistic functions will return a Divide by 0 error.

11-Aug-97

4009

12-Aug-97

3999

3.7

7.5

1300

13-Aug-97

3661

14-Aug-97

3329

15-Aug-97

3797

16-Aug-97

3767

17-Aug-97

3760

18-Aug-97

3653

19-Aug-97

3590

20-Aug-97

12.4

3506

21-Aug-97

2.6

3462

22-Aug-97

3472

23-Aug-97

1.8

3662

24-Aug-97

3999

25-Aug-97

3773

26-Aug-97

3112

0.9

9.9

13.9

1300

27-Aug-97

3420

28-Aug-97

3354

29-Aug-97

3306

30-Aug-97

3445

31-Aug-97

3639

01-Sep-97

4218

02-Sep-97

2951

03-Sep-97

3211

04-Sep-97

3217

05-Sep-97

3144

06-Sep-97

3181

07-Sep-97

3289

08-Sep-97

3233

09-Sep-97

3333

2.2

9.9

19.2

99.9

10-Sep-97

3414

11-Sep-97

3072

12-Sep-97

2739

13-Sep-97

7.8

3201

14-Sep-97

0.8

3388

15-Sep-97

3314

16-Sep-97

3330

17-Sep-97

0.2

3178

18-Sep-97

0.2

3145

19-Sep-97

3302

20-Sep-97

14.4

3487

21-Sep-97

8.8

3635

22-Sep-97

3625

23-Sep-97

9.2

3622

3.4

4.3

9.9

5.3

99.9

24-Sep-97

3378

25-Sep-97

0.6

3449

26-Sep-97

3609

27-Sep-97

0.2

3626

28-Sep-97

0.2

3731

29-Sep-97

17.6

3616

30-Sep-97

2.8

3194

01-Oct-97

3062

02-Oct-97

3560

03-Oct-97

3478

04-Oct-97

3414

05-Oct-97

3199

06-Oct-97

3133

07-Oct-97

3281

2.6

1.9

9.9

0.9

99.9

08-Oct-97

31.8

3652

09-Oct-97

3730

10-Oct-97

3376

11-Oct-97

3354

12-Oct-97

3480

13-Oct-97

3377

14-Oct-97

3225

15-Oct-97

3116

16-Oct-97

3156

17-Oct-97

3217

18-Oct-97

3067

19-Oct-97

0.4

3296

20-Oct-97

29.8

3428

21-Oct-97

5.8

2914

1.6

2.6

1.9

9.9

4.3

99.9

22-Oct-97

16.2

3253

23-Oct-97

1.4

3395

24-Oct-97

3367

25-Oct-97

3341

26-Oct-97

3482

27-Oct-97

3471

28-Oct-97

2872

29-Oct-97

3175

30-Oct-97

8.8

3163

31-Oct-97

2260

01-Nov-97

02-Nov-97

3317

03-Nov-97

3199

04-Nov-97

3120

5.3

4.6

9.9

37.4

05-Nov-97

3.6

3031

06-Nov-97

4.2

3068

07-Nov-97

0.8

3113

08-Nov-97

3272

09-Nov-97

4.2

3185

10-Nov-97

3188

11-Nov-97

3380

12-Nov-97

2898

13-Nov-97

3.2

3131

14-Nov-97

3058

15-Nov-97

2.8

2956

16-Nov-97

1.4

4083

17-Nov-97

10.6

3359

18-Nov-97

8.6

2129

3.6

9.9

19-Nov-97

5.8

3009

20-Nov-97

3083

21-Nov-97

4028

22-Nov-97

4404

23-Nov-97

1.6

1651

24-Nov-97

3328

25-Nov-97

2023

26-Nov-97

3021

27-Nov-97

2974

28-Nov-97

2999

29-Nov-97

3035

30-Nov-97

2141

01-Dec-97

20.4

3406

02-Dec-97

3357

5.8

3.6

9.9

34.7

03-Dec-97

3419

04-Dec-97

2965

05-Dec-97

2710

06-Dec-97

3018

07-Dec-97

3151

08-Dec-97

6.8

3083

09-Dec-97

3063

10-Dec-97

1.8

3075

11-Dec-97

3013

12-Dec-97

3108

13-Dec-97

3132

14-Dec-97

3267

15-Dec-97

3476

16-Dec-97

2866

7.6

1.9

9.9

66.8

17-Dec-97

3156

18-Dec-97

3118

19-Dec-97

3116

20-Dec-97

3250

21-Dec-97

3329

22-Dec-97

3297

23-Dec-97

0.2

3272

24-Dec-97

3453

25-Dec-97

3422

26-Dec-97

37.6

3618

27-Dec-97

2.8

3940

28-Dec-97

0.2

3869

29-Dec-97

3846

9.9

100

30-Dec-97

3807

31-Dec-97

3831

01-Jan-98

0.2

3762

02-Jan-98

1.8

3776

03-Jan-98

3914

04-Jan-98

3979

05-Jan-98

4498

06-Jan-98

6077

07-Jan-98

4.2

3616

08-Jan-98

3435

09-Jan-98

0.6

3615

10-Jan-98

0.2

3894

11-Jan-98

0.4

3638

12-Jan-98

1.8

2307

13-Jan-98

3145

1.9

9.9

185

14-Jan-98

3577

15-Jan-98

3006

16-Jan-98

2.2

3441

17-Jan-98

4.8

3416

18-Jan-98

3381

19-Jan-98

3414

20-Jan-98

3144

21-Jan-98

2802

22-Jan-98

3244

23-Jan-98

3424

24-Jan-98

2778

25-Jan-98

3142

26-Jan-98

0.2

3139

27-Jan-98

3167

9.9

192

28-Jan-98

3022

29-Jan-98

0.4

2898

30-Jan-98

2981

31-Jan-98

29.8

3018

01-Feb-98

30.4

2972

02-Feb-98

3241

03-Feb-98

3038

04-Feb-98

2988

05-Feb-98

2953

06-Feb-98

2985

07-Feb-98

2938

08-Feb-98

3110

09-Feb-98

3172

10-Feb-98

14.4

2899

4.5

380

33.4

11-Feb-98

3447

12-Feb-98

3419

13-Feb-98

8.6

3215

14-Feb-98

3186

15-Feb-98

3474

16-Feb-98

3522

17-Feb-98

2893

18-Feb-98

3027

19-Feb-98

2984

20-Feb-98

3044

21-Feb-98

0.4

3073

22-Feb-98

3213

23-Feb-98

3154

24-Feb-98

3163

8.5

9.9

130.8

25-Feb-98

0.1

2909

26-Feb-98

2923

27-Feb-98

2907

28-Feb-98

2994

01-Mar-98

17.8

3131

02-Mar-98

3119

03-Mar-98

3037

04-Mar-98

3054

05-Mar-98

2964

06-Mar-98

2971

07-Mar-98

1.2

2999

08-Mar-98

0.8

3051

09-Mar-98

3097

10-Mar-98

3051

6.2

1.9

9.9

11-Mar-98

3050

12-Mar-98

3041

13-Mar-98

2954

14-Mar-98

3034

15-Mar-98

3247

16-Mar-98

3364

17-Mar-98

2643

18-Mar-98

3060

19-Mar-98

3002

20-Mar-98

2912

21-Mar-98

3049

22-Mar-98

3075

23-Mar-98

2884

24-Mar-98

2913

9.9

25-Mar-98

0.4

2894

26-Mar-98

2915

27-Mar-98

3129

28-Mar-98

0.2

3407

29-Mar-98

3423

30-Mar-98

3152

31-Mar-98

2899

01-Apr-98

2979

02-Apr-98

0.6

3041

03-Apr-98

0.2

2980

04-Apr-98

0.4

3138

05-Apr-98

3379

06-Apr-98

0.2

3382

07-Apr-98

2624

3.6

08-Apr-98

2973

09-Apr-98

0.4

3076

10-Apr-98

3254

11-Apr-98

3517

12-Apr-98

3498

13-Apr-98

3525

14-Apr-98

3677

15-Apr-98

57.8

3719

16-Apr-98

15.6

3936

17-Apr-98

4465

18-Apr-98

32.2

4229

19-Apr-98

21.4

5207

20-Apr-98

0.8

5155

21-Apr-98

1.6

4352

2.4

1.9

9.9

22-Apr-98

4222

23-Apr-98

4304

24-Apr-98

50.2

4887

25-Apr-98

4912

26-Apr-98

4469

27-Apr-98

4159

28-Apr-98

4034

29-Apr-98

3947

30-Apr-98

3832

01-May-98

3803

02-May-98

3802

03-May-98

3.4

4071

04-May-98

4608

05-May-98

75.6

5948

3.2

3.4

1.9

9.9

06-May-98

6142

07-May-98

5235

08-May-98

4749

09-May-98

4593

10-May-98

4611

11-May-98

4611

12-May-98

3743

13-May-98

0.6

4042

14-May-98

4060

15-May-98

1.6

4297

16-May-98

5069

17-May-98

19.2

5707

18-May-98

2.6

4861

19-May-98

4.6

4907

2.2

1.9

9.9

20-May-98

4703

21-May-98

4497

22-May-98

4241

23-May-98

4046

24-May-98

4155

25-May-98

4067

26-May-98

3989

27-May-98

3802

28-May-98

3753

29-May-98

3718

30-May-98

3803

31-May-98

0.2

4231

01-Jun-98

4848

02-Jun-98

3.4

3240

1.6

9.9

5.3

03-Jun-98

4232

04-Jun-98

3544

05-Jun-98

3838

06-Jun-98

3840

07-Jun-98

3748

08-Jun-98

3723

09-Jun-98

3823

10-Jun-98

3649

11-Jun-98

3605

12-Jun-98

3541

13-Jun-98

3602

14-Jun-98

3650

15-Jun-98

3517

16-Jun-98

3445

1.8

1.9

17-Jun-98

7.2

3872

18-Jun-98

49.2

5356

19-Jun-98

5820

20-Jun-98

13.4

5633

21-Jun-98

5351

22-Jun-98

4784

23-Jun-98

6.8

4802

24-Jun-98

4472

25-Jun-98

4438

26-Jun-98

4201

27-Jun-98

0.6

4177

28-Jun-98

0.2

4260

29-Jun-98

4139

30-Jun-98

2.6

4008

2.6

0.4

Statistics calculated using Excels Functions in the Analysis

Toolpak.

STATISTICS

IMPORTANT: Leave one blank row between table and stats

Samples

375

ROW(End)-ROW(End-Start)

Mean

3.89

3596.85

7.62

4.55

2.63

24.00

38.68

677.73

#DIV/0!

AVERAGE(LABEL)

Stdev

11.31

773.68

8.93

2.95

1.42

71.17

53.88

599.06

#DIV/0!

STDEV(LABEL)

Max

130.60

9487.00

32.00

12.00

6.00

380.00

192.00

1400.00

0.00

MAX(LABEL)

Min

0.00

1651.00

0.90

1.60

0.00

9.90

0.00

99.90

0.00

MIN(LABEL)

10th %ile

0.00

2971.30

1.00

2.12

1.90

9.90

1.62

99.90

#NUM!

PERCENTILE(LABEL,0.1)

25th %ile

0.00

3113.75

1.55

2.60

1.90

9.90

4.80

99.90

#NUM!

PERCENTILE(LABEL,0.25)

50th %ile

0.00

3391.50

3.20

3.60

1.90

9.90

16.00

550.00

#NUM!

PERCENTILE(LABEL,0.5)

75th %ile

1.80

3869.75

12.00

5.30

3.50

9.90

49.20

1300.00

#NUM!

PERCENTILE(LABEL,0.75)

80th %ile

3.00

4062.80

14.60

6.16

4.00

9.98

61.80

1300.00

#NUM!

PERCENTILE(LABEL,0.8)

90th %ile

12.00

4500.10

19.00

9.10

4.58

10.00

112.32

1320.00

#NUM!

PERCENTILE(LABEL,0.90)

95th %ile

20.72

4960.45

27.60

11.40

5.00

17.00

168.74

1360.00

#NUM!

PERCENTILE(LABEL,0.95)